Indexed Step Wise Semi Naive Evaluation for Recursive Queries

نویسندگان

  • Ke Wang
  • Weining Zhang
چکیده

A nice property of the semi naive evaluation of recursive rules is that it does not repeat rule rings in di erent iterations In a recent study W however it was observed that intermediate steps during a rule ring may be repeated in di erent iterations and a notion of the step wise semi naive property and an evaluation with this property were proposed to capture the semi naive prop erty at intermediate steps of a rule ring In this paper we further extend the semi naive notion to the build up of index for computing relations that grow monotonically in each iteration Hash tables are chosen as the index in this study but the idea can be applied to other types of index in general A modi cation of the step wise semi naive evaluation based on the semi naive build up of hash tables is proposed In most cases join set di erence and set union operations performed to re a rule are implemented in a single I O scan of relations that are cumulated up to that iteration Experiments conducted on a few typical recursive queries and test data show that the proposed evaluation is much more I O cost e ective than both the semi naive evaluation and the step wise semi naive evaluation

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Efficient Implementation of Loops in Bottom-Up Evaluation of Logic Queries

We consider the efficient implementation of the bottom-up evaluation method for recursive queries in logic databases. In the bottom-up evaluation algorithms the non-mutually-recursive rules are evaluated in certain order, whereas the evaluation order within a set of the mutually recursive rules is free. However, significant savings in join operations can be achieved by arranging the mutually re...

متن کامل

Dynamically Ordered Semi-Naive Evaluation of Recursive Queries

Conventional fixed point evaluation techniques evaluate recursions by applying all rules repeatedly using an initial set of tuples (i.e., a given extensional database instance) until no new tuples are generated, but there is no specific order in which rules are applied. We can speed up the evaluation by applying rules in an appropriate order. In this paper, we propose a new fixed point evaluati...

متن کامل

Query Evaluation in Recursive Databases: Bottom-up and Top-down Reconciled

It is desirable to answer queries' posed to deductive databases by computing fixpoints because such computations are directly amenable to set-oriented fact processing. However, the classical fixpoint procedures based on bottom-up processingthe naive and semi-naive methodsare rather primitive and often inefficient. In this article, we rely on bottom-up meta-interpretation for formalizing a new f...

متن کامل

Implementing Generalized Transitive Closure in the Paradise Geographical Information System

The generalized transitive closure operator can be used to ask and answer a number of sophisticated queries on a database which is viewed as a directed graph. These queries cannot be expressed in SQL or relational algebra and neither can they be answered by commercially available relational or object-oriented database systems. In this report we describe the design and implementation of the gene...

متن کامل

Optimizing Large-Scale Semi-Naïve Datalog Evaluation in Hadoop

We explore the design and implementation of a scalable Datalog system using Hadoop as the underlying runtime system. Observing that several successful projects provide a relational algebra-based programming interface to Hadoop, we argue that a natural extension is to add recursion to support scalable social network analysis, internet traffic analysis, and general graph query. We implement semi-...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1994